PluginProbe
Visualizer – Tables & Charts Manager with Built-in AI Generator / 3.1.1
Visualizer – Tables & Charts Manager with Built-in AI Generator v3.1.1
4.0.8 4.0.7 4.0.6 4.0.5 4.0.4 4.0.3 3.0.5 3.0.6 3.0.7 3.0.8 3.0.9 3.1.0 3.1.1 3.1.2 3.1.3 3.10.0 3.10.1 3.10.10 3.10.11 3.10.12 3.10.13 3.10.14 3.10.15 3.10.2 3.10.3 All 149 releases
visualizer / vendor / phpoffice / phpexcel / Documentation / Examples / Reading WorkBook Data / exampleWorkBookReader01.php

exampleWorkBookReader01.php in Visualizer – Tables & Charts Manager with Built-in AI Generator 3.1.1, at vendor/phpoffice/phpexcel/Documentation/Examples/Reading WorkBook Data/exampleWorkBookReader01.php

94 lines 3.0 KB
No matching file
Up and down to move Enter to open Esc to close
Raw Download Zip
1 <?php
2
3 error_reporting(E_ALL);
4 set_time_limit(0);
5
6 date_default_timezone_set('Europe/London');
7
8 ?>
9 <html>
10 <head>
11 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
12
13 <title>PHPExcel Reading WorkBook Data Example #01</title>
14
15 </head>
16 <body>
17
18 <h1>PHPExcel Reading WorkBook Data Example #01</h1>
19 <h2>Read the WorkBook Properties</h2>
20 <?php
21
22 /** Include path **/
23 set_include_path(get_include_path() . PATH_SEPARATOR . '../../../Classes/');
24
25 /** PHPExcel_IOFactory */
26 include 'PHPExcel/IOFactory.php';
27
28
29 $inputFileType = 'Excel5';
30 $inputFileName = './sampleData/example1.xls';
31
32 /** Create a new Reader of the type defined in $inputFileType **/
33 $objReader = PHPExcel_IOFactory::createReader($inputFileType);
34 /** Load $inputFileName to a PHPExcel Object **/
35 $objPHPExcel = $objReader->load($inputFileName);
36
37
38 echo '<hr />';
39
40 /** Read the document's creator property **/
41 $creator = $objPHPExcel->getProperties()->getCreator();
42 echo '<b>Document Creator: </b>',$creator,'<br />';
43
44 /** Read the Date when the workbook was created (as a PHP timestamp value) **/
45 $creationDatestamp = $objPHPExcel->getProperties()->getCreated();
46 /** Format the date and time using the standard PHP date() function **/
47 $creationDate = date('l, d<\s\up>S</\s\up> F Y',$creationDatestamp);
48 $creationTime = date('g:i A',$creationDatestamp);
49 echo '<b>Created On: </b>',$creationDate,' at ',$creationTime,'<br />';
50
51 /** Read the name of the last person to modify this workbook **/
52 $modifiedBy = $objPHPExcel->getProperties()->getLastModifiedBy();
53 echo '<b>Last Modified By: </b>',$modifiedBy,'<br />';
54
55 /** Read the Date when the workbook was last modified (as a PHP timestamp value) **/
56 $modifiedDatestamp = $objPHPExcel->getProperties()->getModified();
57 /** Format the date and time using the standard PHP date() function **/
58 $modifiedDate = date('l, d<\s\up>S</\s\up> F Y',$modifiedDatestamp);
59 $modifiedTime = date('g:i A',$modifiedDatestamp);
60 echo '<b>Last Modified On: </b>',$modifiedDate,' at ',$modifiedTime,'<br />';
61
62 /** Read the workbook title property **/
63 $workbookTitle = $objPHPExcel->getProperties()->getTitle();
64 echo '<b>Title: </b>',$workbookTitle,'<br />';
65
66 /** Read the workbook description property **/
67 $description = $objPHPExcel->getProperties()->getDescription();
68 echo '<b>Description: </b>',$description,'<br />';
69
70 /** Read the workbook subject property **/
71 $subject = $objPHPExcel->getProperties()->getSubject();
72 echo '<b>Subject: </b>',$subject,'<br />';
73
74 /** Read the workbook keywords property **/
75 $keywords = $objPHPExcel->getProperties()->getKeywords();
76 echo '<b>Keywords: </b>',$keywords,'<br />';
77
78 /** Read the workbook category property **/
79 $category = $objPHPExcel->getProperties()->getCategory();
80 echo '<b>Category: </b>',$category,'<br />';
81
82 /** Read the workbook company property **/
83 $company = $objPHPExcel->getProperties()->getCompany();
84 echo '<b>Company: </b>',$company,'<br />';
85
86 /** Read the workbook manager property **/
87 $manager = $objPHPExcel->getProperties()->getManager();
88 echo '<b>Manager: </b>',$manager,'<br />';
89
90
91 ?>
92 <body>
93 </html>
94